home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
vrptfaremaps.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
579b
|
19 lines
CREATE OR REPLACE VIEW vrptfaremaps AS
SELECT RPTNAMES.SHORT_NAME,
RPTFAREMAP.REPORT_INDX,RPTFAREMAP.RPTCLASS,RPTHEADERS.HEADER,
RPTFAREMAP.FARESET_ID, RPTFAREMAP.FARE_ID,
RPTFAREMAP.CONFIG_NUM,
RPTNAMES.IS_CUSTOMIZABLE, RPTNAMES.MAX_COLUMNS,
RPTNAMES.REPORT_NAME
FROM
RPTFAREMAP,
RPTNAMES RPTNAMES,
RPTHEADERS
WHERE
( RPTHEADERS.RPTCLASS=RPTFAREMAP.RPTCLASS ) AND
( RPTFAREMAP.REPORT_INDX=RPTFAREMAP.REPORT_INDX ) AND
( RPTFAREMAP.REPORT_INDX=RPTNAMES.REPORT_INDX )AND
RPTHEADERS.REPORT_INDX = RPTFAREMAP.REPORT_INDX
;